<?php
class ControllerCatalogLgiProduct extends Controller {
  private $error = array();

  public function index() {
    $this->load->language('catalog/lgi_product');

    $this->document->setTitle($this->language->get('heading_title'));

    $this->load->model('catalog/lgi_product');

    $this->getList();
  }

  public function edit() {
    $this->load->language('catalog/mvd_product');

    $this->document->setTitle($this->language->get('heading_title'));

    $this->load->model('catalog/lgi_product');

    $this->getForm();
  }


  protected function getList() {
    if (isset($this->request->get['filter_name'])) {
      $filter_name = $this->request->get['filter_name'];
    } else {
      $filter_name = null;
    }

    if (isset($this->request->get['filter_model'])) {
      $filter_model = $this->request->get['filter_model'];
    } else {
      $filter_model = null;
    }

    if (isset($this->request->get['filter_price'])) {
      $filter_price = $this->request->get['filter_price'];
    } else {
      $filter_price = null;
    }

    if (isset($this->request->get['filter_quantity'])) {
      $filter_quantity = $this->request->get['filter_quantity'];
    } else {
      $filter_quantity = null;
    }

    if (isset($this->request->get['filter_status'])) {
      $filter_status = $this->request->get['filter_status'];
    } else {
      $filter_status = null;
    }
    
    //lgis
    if (isset($this->request->get['filter_sku'])) {
      $filter_sku = $this->request->get['filter_sku'];
    } else {
      $filter_sku = null;
    }
      
    if (isset($this->request->get['filter_vendor'])) {
      $filter_vendor = $this->request->get['filter_vendor'];
    } else {
      $filter_vendor = NULL;
    }
      
    if (isset($this->request->get['filter_vendor_name'])) {
      $filter_vendor_name = $this->request->get['filter_vendor_name'];
    } else {
      $filter_vendor_name = NULL;
    }
    //lgie

    if (isset($this->request->get['sort'])) {
      $sort = $this->request->get['sort'];
    } else {
      $sort = 'pd.name';
    }

    if (isset($this->request->get['order'])) {
      $order = $this->request->get['order'];
    } else {
      $order = 'ASC';
    }

    if (isset($this->request->get['page'])) {
      $page = $this->request->get['page'];
    } else {
      $page = 1;
    }

    $url = '';

    if (isset($this->request->get['filter_name'])) {
      $url .= '&filter_name=' . urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES, 'UTF-8'));
    }

    if (isset($this->request->get['filter_model'])) {
      $url .= '&filter_model=' . urlencode(html_entity_decode($this->request->get['filter_model'], ENT_QUOTES, 'UTF-8'));
    }
    
    //lgis
    if (isset($this->request->get['filter_sku'])) {
      $url .= '&filter_sku=' . urlencode(html_entity_decode($this->request->get['filter_sku'], ENT_QUOTES, 'UTF-8'));
    }
      
    if (isset($this->request->get['filter_vendor_name'])) {
      $url .= '&filter_vendor_name=' . urlencode(html_entity_decode($this->request->get['filter_vendor_name'], ENT_QUOTES, 'UTF-8'));
    }
      
    if (isset($this->request->get['filter_vendor'])) {
      $url .= '&filter_vendor=' . urlencode(html_entity_decode($this->request->get['filter_vendor'], ENT_QUOTES, 'UTF-8'));
    }
    //lgie

    if (isset($this->request->get['filter_price'])) {
      $url .= '&filter_price=' . $this->request->get['filter_price'];
    }

    if (isset($this->request->get['filter_quantity'])) {
      $url .= '&filter_quantity=' . $this->request->get['filter_quantity'];
    }

    if (isset($this->request->get['filter_status'])) {
      $url .= '&filter_status=' . $this->request->get['filter_status'];
    }

    if (isset($this->request->get['sort'])) {
      $url .= '&sort=' . $this->request->get['sort'];
    }

    if (isset($this->request->get['order'])) {
      $url .= '&order=' . $this->request->get['order'];
    }

    if (isset($this->request->get['page'])) {
      $url .= '&page=' . $this->request->get['page'];
    }

    $data['breadcrumbs'] = array();

    $data['breadcrumbs'][] = array(
      'text' => $this->language->get('text_home'),
      'href' => $this->url->link('common/dashboard', 'token=' . $this->session->data['token'], 'SSL')
    );

    $data['breadcrumbs'][] = array(
      'text' => $this->language->get('heading_title'),
      'href' => $this->url->link('catalog/lgi_product', 'token=' . $this->session->data['token'] . $url, 'SSL')
    );

    $data['products'] = array();

    $filter_data = array(
      'filter_name'   => $filter_name,
      'filter_model'    => $filter_model,
      'filter_price'    => $filter_price,
      //lgis
      'filter_sku'       => $filter_sku,
      'filter_vendor'        => $filter_vendor, 
      'filter_vendor_name'   => $filter_vendor_name,
      //lgie
      'filter_quantity' => $filter_quantity,
      'filter_status'   => $filter_status,
      'sort'            => $sort,
      'order'           => $order,
      'start'           => ($page - 1) * $this->config->get('config_limit_admin'),
      'limit'           => $this->config->get('config_limit_admin')
    );

    $this->load->model('tool/image');

    $product_total = $this->model_catalog_lgi_product->getTotalProducts($filter_data);

    $results = $this->model_catalog_lgi_product->getProducts($filter_data);
    //lgis
    $data['vendors'] = $this->model_catalog_lgi_product->getVendors();
    //lgie
    
    foreach ($results as $result) {
      if (is_file(DIR_IMAGE . $result['image'])) {
        $image = $this->model_tool_image->resize($result['image'], 40, 40);
      } else {
        $image = $this->model_tool_image->resize('no_image.png', 40, 40);
      }

      $special = false;

      $product_specials = $this->model_catalog_lgi_product->getProductSpecials($result['product_id']);

      foreach ($product_specials  as $product_special) {
        if (($product_special['date_start'] == '0000-00-00' || strtotime($product_special['date_start']) < time()) && ($product_special['date_end'] == '0000-00-00' || strtotime($product_special['date_end']) > time())) {
        
          $special = $product_special['price'];

          break;
        }
      }

      //qty & status for currenty logcenter
      $lg_product_info = $this->model_catalog_lgi_product->getLgProductInfo($result['product_id']);
      $lg_product_info = empty($lg_product_info)?array('status'=>1, 'quantity'=>0):$lg_product_info;
      //option qty for currenty logcenter
      // $lg_product_opt_qty = $this->model_catalog_lgi_product->getLgProductOptionQty($result['product_id']);
      
      //lgis
      if ($lg_product_info['status'] == 5) {
        $status = $this->language->get('txt_pending_approval');
      } elseif ($lg_product_info['status']) {
        $status = $this->language->get('text_enabled');
      } else {
        $status = $this->language->get('text_disabled');
      }
      //lgie
      
      $data['products'][] = array(
        'product_id' => $result['product_id'],
        'image'      => $image,
        'name'       => $result['name'],
        'model'      => $result['model'],
        'price'      => $result['price'],
        'special'    => $special,
        //lgis
        'sku'        => $result['sku'],
        'vendor_name'=> $result['vendor_name'],
        'status'     => $status,
        //lgie
        // 'quantity'   => $lg_product_info['quantity'],
        // 'lg_product_opt_qty' => $lg_product_opt_qty,
        //'status'     => ($result['status']) ? $this->language->get('text_enabled') : $this->language->get('text_disabled'),
        'edit'       => $this->url->link('catalog/lgi_product/edit', 'token=' . $this->session->data['token'] . '&product_id=' . $result['product_id'] . $url, 'SSL')
      );
    }

    $data['heading_title'] = $this->language->get('heading_title');
    
    $data['text_list'] = $this->language->get('text_list');
    $data['text_enabled'] = $this->language->get('text_enabled');
    $data['text_disabled'] = $this->language->get('text_disabled');
    $data['text_no_results'] = $this->language->get('text_no_results');
    $data['text_confirm'] = $this->language->get('text_confirm');
    //lgis
    $data['column_vendor'] = $this->language->get('column_vendor');
    $data['column_sku'] = $this->language->get('column_sku');
    $data['entry_vendor_name'] = $this->language->get('entry_vendor_name');
    $data['entry_sku'] = $this->language->get('entry_sku');
    $data['txt_pending_approval'] = $this->language->get('txt_pending_approval');
    //lgie

    $data['column_image'] = $this->language->get('column_image');
    $data['column_name'] = $this->language->get('column_name');
    $data['column_model'] = $this->language->get('column_model');
    $data['column_price'] = $this->language->get('column_price');
    $data['column_quantity'] = $this->language->get('column_quantity');
    $data['column_status'] = $this->language->get('column_status');
    $data['column_action'] = $this->language->get('column_action');
    $data['entry_name'] = $this->language->get('entry_name');
    $data['entry_model'] = $this->language->get('entry_model');
    $data['entry_price'] = $this->language->get('entry_price');
    $data['entry_quantity'] = $this->language->get('entry_quantity');
    $data['entry_status'] = $this->language->get('entry_status');

    $data['button_copy'] = $this->language->get('button_copy');
    $data['button_add'] = $this->language->get('button_add');
    $data['button_edit'] = $this->language->get('button_edit');
    $data['button_delete'] = $this->language->get('button_delete');
    $data['button_filter'] = $this->language->get('button_filter');
    $data['button_view'] = $this->language->get('button_view');

    $data['token'] = $this->session->data['token'];

    if (isset($this->error['warning'])) {
      $data['error_warning'] = $this->error['warning'];
    } else {
      $data['error_warning'] = '';
    }

    if (isset($this->session->data['success'])) {
      $data['success'] = $this->session->data['success'];

      unset($this->session->data['success']);
    } else {
      $data['success'] = '';
    }

    if (isset($this->request->post['selected'])) {
      $data['selected'] = (array)$this->request->post['selected'];
    } else {
      $data['selected'] = array();
    }

    $url = '';

    if (isset($this->request->get['filter_name'])) {
      $url .= '&filter_name=' . urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES, 'UTF-8'));
    }
    
    //lgis
    if (isset($this->request->get['filter_sku'])) {
      $url .= '&filter_sku=' . urlencode(html_entity_decode($this->request->get['filter_sku'], ENT_QUOTES, 'UTF-8'));
    }
      
    if (isset($this->request->get['filter_vendor_name'])) {
      $url .= '&filter_vendor_name=' . urlencode(html_entity_decode($this->request->get['filter_vendor_name'], ENT_QUOTES, 'UTF-8'));
    }
      
    if (isset($this->request->get['filter_vendor'])) {
      $url .= '&filter_vendor=' . urlencode(html_entity_decode($this->request->get['filter_vendor'], ENT_QUOTES, 'UTF-8'));
    }
    //lgie

    if (isset($this->request->get['filter_model'])) {
      $url .= '&filter_model=' . urlencode(html_entity_decode($this->request->get['filter_model'], ENT_QUOTES, 'UTF-8'));
    }

    if (isset($this->request->get['filter_price'])) {
      $url .= '&filter_price=' . $this->request->get['filter_price'];
    }

    if (isset($this->request->get['filter_quantity'])) {
      $url .= '&filter_quantity=' . $this->request->get['filter_quantity'];
    }

    if (isset($this->request->get['filter_status'])) {
      $url .= '&filter_status=' . $this->request->get['filter_status'];
    }

    if ($order == 'ASC') {
      $url .= '&order=DESC';
    } else {
      $url .= '&order=ASC';
    }

    if (isset($this->request->get['page'])) {
      $url .= '&page=' . $this->request->get['page'];
    }

    $data['sort_name'] = $this->url->link('catalog/lgi_product', 'token=' . $this->session->data['token'] . '&sort=pd.name' . $url, 'SSL');
    $data['sort_model'] = $this->url->link('catalog/lgi_product', 'token=' . $this->session->data['token'] . '&sort=p.model' . $url, 'SSL');
    $data['sort_price'] = $this->url->link('catalog/lgi_product', 'token=' . $this->session->data['token'] . '&sort=p.price' . $url, 'SSL');
    $data['sort_quantity'] = $this->url->link('catalog/lgi_product', 'token=' . $this->session->data['token'] . '&sort=p.quantity' . $url, 'SSL');
    $data['sort_status'] = $this->url->link('catalog/lgi_product', 'token=' . $this->session->data['token'] . '&sort=p.status' . $url, 'SSL');
    $data['sort_order'] = $this->url->link('catalog/lgi_product', 'token=' . $this->session->data['token'] . '&sort=p.sort_order' . $url, 'SSL');
    //lgis
    $data['sort_sku'] = $this->url->link('catalog/lgi_product', 'token=' . $this->session->data['token'] . '&sort=p.sku' . $url, 'SSL');
    $data['sort_vendor_name'] = $this->url->link('catalog/lgi_product', 'token=' . $this->session->data['token'] . '&sort=vds.vendor_id' . $url, 'SSL');
    //lgie
    
    $url = '';

    if (isset($this->request->get['filter_name'])) {
      $url .= '&filter_name=' . urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES, 'UTF-8'));
    }

    if (isset($this->request->get['filter_model'])) {
      $url .= '&filter_model=' . urlencode(html_entity_decode($this->request->get['filter_model'], ENT_QUOTES, 'UTF-8'));
    }
    
    //lgis
    if (isset($this->request->get['filter_sku'])) {
      $url .= '&filter_sku=' . urlencode(html_entity_decode($this->request->get['filter_sku'], ENT_QUOTES, 'UTF-8'));
    }
      
    if (isset($this->request->get['filter_vendor_name'])) {
      $url .= '&filter_vendor_name=' . urlencode(html_entity_decode($this->request->get['filter_vendor_name'], ENT_QUOTES, 'UTF-8'));
    }
    //lgie

    if (isset($this->request->get['filter_price'])) {
      $url .= '&filter_price=' . $this->request->get['filter_price'];
    }

    if (isset($this->request->get['filter_quantity'])) {
      $url .= '&filter_quantity=' . $this->request->get['filter_quantity'];
    }

    if (isset($this->request->get['filter_status'])) {
      $url .= '&filter_status=' . $this->request->get['filter_status'];
    }

    if (isset($this->request->get['sort'])) {
      $url .= '&sort=' . $this->request->get['sort'];
    }

    if (isset($this->request->get['order'])) {
      $url .= '&order=' . $this->request->get['order'];
    }

    $pagination = new Pagination();
    $pagination->total = $product_total;
    $pagination->page = $page;
    $pagination->limit = $this->config->get('config_limit_admin');
    $pagination->url = $this->url->link('catalog/lgi_product', 'token=' . $this->session->data['token'] . $url . '&page={page}', 'SSL');

    $data['pagination'] = $pagination->render();

    $data['results'] = sprintf($this->language->get('text_pagination'), ($product_total) ? (($page - 1) * $this->config->get('config_limit_admin')) + 1 : 0, ((($page - 1) * $this->config->get('config_limit_admin')) > ($product_total - $this->config->get('config_limit_admin'))) ? $product_total : ((($page - 1) * $this->config->get('config_limit_admin')) + $this->config->get('config_limit_admin')), $product_total, ceil($product_total / $this->config->get('config_limit_admin')));

    $data['filter_name'] = $filter_name;
    $data['filter_model'] = $filter_model;
    //lgis
    $data['filter_sku'] = $filter_sku;
    $data['filter_vendor_name'] = $filter_vendor_name;
    //lgie
    $data['filter_price'] = $filter_price;
    $data['filter_quantity'] = $filter_quantity;
    $data['filter_status'] = $filter_status;

    $data['sort'] = $sort;
    $data['order'] = $order;

    $data['batch_enable'] = $this->url->link('catalog/lgi_product/batch', 'token=' . $this->session->data['token'] . '&enable=1', 'SSL');
    $data['batch_disable'] = $this->url->link('catalog/lgi_product/batch', 'token=' . $this->session->data['token'] . '&enable=0', 'SSL');

    $data['header'] = $this->load->controller('common/header');
    $data['column_left'] = $this->load->controller('common/column_left');
    $data['footer'] = $this->load->controller('common/footer');

    $this->response->setOutput($this->load->view('catalog/lgi_product_list.tpl', $data));
  }

  protected function getForm() {
    $data['heading_title'] = $this->language->get('heading_title');
    
    $data['text_form'] = !isset($this->request->get['product_id']) ? $this->language->get('text_add') : $this->language->get('text_edit');
    $data['text_enabled'] = $this->language->get('text_enabled');
    $data['text_disabled'] = $this->language->get('text_disabled');
    $data['text_none'] = $this->language->get('text_none');
    $data['text_yes'] = $this->language->get('text_yes');
    $data['text_no'] = $this->language->get('text_no');
    $data['text_plus'] = $this->language->get('text_plus');
    $data['text_minus'] = $this->language->get('text_minus');
    $data['text_default'] = $this->language->get('text_default');
    $data['text_option'] = $this->language->get('text_option');
    $data['text_option_value'] = $this->language->get('text_option_value');
    $data['text_select'] = $this->language->get('text_select');
    $data['text_percent'] = $this->language->get('text_percent');
    $data['text_amount'] = $this->language->get('text_amount');

    $data['entry_name'] = $this->language->get('entry_name');
    $data['entry_description'] = $this->language->get('entry_description');
    $data['entry_meta_title'] = $this->language->get('entry_meta_title');
    $data['entry_meta_description'] = $this->language->get('entry_meta_description');
    $data['entry_meta_keyword'] = $this->language->get('entry_meta_keyword');
    $data['entry_keyword'] = $this->language->get('entry_keyword');
    $data['entry_model'] = $this->language->get('entry_model');
    $data['entry_sku'] = $this->language->get('entry_sku');
    $data['entry_upc'] = $this->language->get('entry_upc');
    $data['entry_ean'] = $this->language->get('entry_ean');
    $data['entry_jan'] = $this->language->get('entry_jan');
    $data['entry_isbn'] = $this->language->get('entry_isbn');
    $data['entry_mpn'] = $this->language->get('entry_mpn');
    $data['entry_location'] = $this->language->get('entry_location');
    $data['entry_minimum'] = $this->language->get('entry_minimum');
    $data['entry_shipping'] = $this->language->get('entry_shipping');
    $data['entry_date_available'] = $this->language->get('entry_date_available');
    $data['entry_quantity'] = $this->language->get('entry_quantity');
    $data['entry_stock_status'] = $this->language->get('entry_stock_status');
    $data['entry_price'] = $this->language->get('entry_price');
    $data['entry_tax_class'] = $this->language->get('entry_tax_class');
    $data['entry_points'] = $this->language->get('entry_points');
    $data['entry_option_points'] = $this->language->get('entry_option_points');
    $data['entry_subtract'] = $this->language->get('entry_subtract');
    $data['entry_weight_class'] = $this->language->get('entry_weight_class');
    $data['entry_weight'] = $this->language->get('entry_weight');
    $data['entry_dimension'] = $this->language->get('entry_dimension');
    $data['entry_length_class'] = $this->language->get('entry_length_class');
    $data['entry_length'] = $this->language->get('entry_length');
    $data['entry_width'] = $this->language->get('entry_width');
    $data['entry_height'] = $this->language->get('entry_height');
    $data['entry_image'] = $this->language->get('entry_image');
    $data['entry_store'] = $this->language->get('entry_store');
    $data['entry_manufacturer'] = $this->language->get('entry_manufacturer');
    $data['entry_download'] = $this->language->get('entry_download');
    $data['entry_category'] = $this->language->get('entry_category');
    $data['entry_filter'] = $this->language->get('entry_filter');
    $data['entry_related'] = $this->language->get('entry_related');
    $data['entry_attribute'] = $this->language->get('entry_attribute');
    $data['entry_text'] = $this->language->get('entry_text');
    $data['entry_option'] = $this->language->get('entry_option');
    $data['entry_option_value'] = $this->language->get('entry_option_value');
    $data['entry_required'] = $this->language->get('entry_required');
    $data['entry_sort_order'] = $this->language->get('entry_sort_order');
    $data['entry_status'] = $this->language->get('entry_status');
    $data['entry_date_start'] = $this->language->get('entry_date_start');
    $data['entry_date_end'] = $this->language->get('entry_date_end');
    $data['entry_priority'] = $this->language->get('entry_priority');
    $data['entry_tag'] = $this->language->get('entry_tag');
    $data['entry_customer_group'] = $this->language->get('entry_customer_group');
    $data['entry_reward'] = $this->language->get('entry_reward');
    $data['entry_layout'] = $this->language->get('entry_layout');
    $data['entry_recurring'] = $this->language->get('entry_recurring');

    $data['help_keyword'] = $this->language->get('help_keyword');
    $data['help_sku'] = $this->language->get('help_sku');
    $data['help_upc'] = $this->language->get('help_upc');
    $data['help_ean'] = $this->language->get('help_ean');
    $data['help_jan'] = $this->language->get('help_jan');
    $data['help_isbn'] = $this->language->get('help_isbn');
    $data['help_mpn'] = $this->language->get('help_mpn');
    $data['help_minimum'] = $this->language->get('help_minimum');
    $data['help_manufacturer'] = $this->language->get('help_manufacturer');
    $data['help_stock_status'] = $this->language->get('help_stock_status');
    $data['help_points'] = $this->language->get('help_points');
    $data['help_category'] = $this->language->get('help_category');
    $data['help_filter'] = $this->language->get('help_filter');
    $data['help_download'] = $this->language->get('help_download');
    $data['help_related'] = $this->language->get('help_related');
    $data['help_tag'] = $this->language->get('help_tag');

    $data['button_save'] = $this->language->get('button_save');
    $data['button_cancel'] = $this->language->get('button_cancel');
    $data['button_attribute_add'] = $this->language->get('button_attribute_add');
    $data['button_option_add'] = $this->language->get('button_option_add');
    $data['button_option_value_add'] = $this->language->get('button_option_value_add');
    $data['button_discount_add'] = $this->language->get('button_discount_add');
    $data['button_special_add'] = $this->language->get('button_special_add');
    $data['button_image_add'] = $this->language->get('button_image_add');
    $data['button_remove'] = $this->language->get('button_remove');
    $data['button_recurring_add'] = $this->language->get('button_recurring_add');

    $data['tab_general'] = $this->language->get('tab_general');
    $data['tab_data'] = $this->language->get('tab_data');
    $data['tab_attribute'] = $this->language->get('tab_attribute');
    $data['tab_option'] = $this->language->get('tab_option');
    $data['tab_recurring'] = $this->language->get('tab_recurring');
    $data['tab_discount'] = $this->language->get('tab_discount');
    $data['tab_special'] = $this->language->get('tab_special');
    $data['tab_image'] = $this->language->get('tab_image');
    $data['tab_links'] = $this->language->get('tab_links');
    $data['tab_reward'] = $this->language->get('tab_reward');
    $data['tab_design'] = $this->language->get('tab_design');
    $data['tab_openbay'] = $this->language->get('tab_openbay');
    
    //lgis
    $data['entry_vendor_country_origin'] = $this->language->get('entry_vendor_country_origin');
    $data['entry_vendor_product_cost'] = $this->language->get('entry_vendor_product_cost');
    $data['entry_vendor_shipping_method'] = $this->language->get('entry_vendor_shipping_method');
    $data['entry_vendor_preferred_shipping_method'] = $this->language->get('entry_vendor_preferred_shipping_method');
    $data['entry_vendor_shipping_cost'] = $this->language->get('entry_vendor_shipping_cost');
    $data['entry_vendor_total'] = $this->language->get('entry_vendor_total');
    $data['entry_vendor_company'] = $this->language->get('entry_vendor_company');
    $data['entry_vendor_description'] = $this->language->get('entry_vendor_description');
    $data['entry_vendor_contact_name'] = $this->language->get('entry_vendor_contact_name');
    $data['entry_vendor_telephone'] = $this->language->get('entry_vendor_telephone');
    $data['entry_vendor_fax'] = $this->language->get('entry_vendor_fax');
    $data['entry_vendor_email'] = $this->language->get('entry_vendor_email');
    $data['entry_vendor_paypal_email'] = $this->language->get('entry_vendor_paypal_email');
    $data['entry_vendor_address'] = $this->language->get('entry_vendor_address');
    $data['entry_vendor_country_zone'] = $this->language->get('entry_vendor_country_zone');
    $data['entry_vendor_store_url'] = $this->language->get('entry_vendor_store_url');
    $data['entry_vendor_product_url'] = $this->language->get('entry_vendor_product_url');
    $data['entry_vendor_name'] = $this->language->get('entry_vendor_name');
    $data['entry_vendor_wholesale'] = $this->language->get('entry_vendor_wholesale');
    $data['entry_shipping_rate'] = $this->language->get('entry_shipping_rate');
    $data['tab_vendor'] = $this->language->get('tab_vendor');
    $data['tab_shipping'] = $this->language->get('tab_shipping');
    $data['txt_pending_approval'] = $this->language->get('txt_pending_approval');
      
    $data['entry_shipping_courier'] = $this->language->get('entry_shipping_courier');
    $data['entry_shipping_cost'] = $this->language->get('entry_shipping_cost');
    $data['entry_shipping_geozone'] = $this->language->get('entry_shipping_geozone');
    $data['button_add_shipping'] = $this->language->get('button_add_shipping');
    
    $data['help_vendor_country_origin'] = $this->language->get('help_vendor_country_origin');
    $data['help_vendor_shipping_method'] = $this->language->get('help_vendor_shipping_method');
    $data['help_vendor_preferred_shipping_method'] = $this->language->get('help_vendor_preferred_shipping_method');
    $data['help_vendor_total'] = $this->language->get('help_vendor_total');
    //lgie

    if (isset($this->error['warning'])) {
      $data['error_warning'] = $this->error['warning'];
    } else {
      $data['error_warning'] = '';
    }

    if (isset($this->error['name'])) {
      $data['error_name'] = $this->error['name'];
    } else {
      $data['error_name'] = array();
    }

    if (isset($this->error['meta_title'])) {
      $data['error_meta_title'] = $this->error['meta_title'];
    } else {
      $data['error_meta_title'] = array();
    }

    if (isset($this->error['model'])) {
      $data['error_model'] = $this->error['model'];
    } else {
      $data['error_model'] = '';
    }

    if (isset($this->error['date_available'])) {
      $data['error_date_available'] = $this->error['date_available'];
    } else {
      $data['error_date_available'] = '';
    }
    
    if (isset($this->error['keyword'])) {
      $data['error_keyword'] = $this->error['keyword'];
    } else {
      $data['error_keyword'] = '';
    }

    $url = '';

    if (isset($this->request->get['filter_name'])) {
      $url .= '&filter_name=' . urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES, 'UTF-8'));
    }
    
    //lgis
    if (isset($this->request->get['filter_sku'])) {
      $url .= '&filter_sku=' . urlencode(html_entity_decode($this->request->get['filter_sku'], ENT_QUOTES, 'UTF-8'));
    }
      
    if (isset($this->request->get['filter_vendor_name'])) {
      $url .= '&filter_vendor_name=' . urlencode(html_entity_decode($this->request->get['filter_vendor_name'], ENT_QUOTES, 'UTF-8'));
    }
      
    if (isset($this->request->get['filter_vendor'])) {
      $url .= '&filter_vendor=' . urlencode(html_entity_decode($this->request->get['filter_vendor'], ENT_QUOTES, 'UTF-8'));
    }
    //lgie

    if (isset($this->request->get['filter_model'])) {
      $url .= '&filter_model=' . urlencode(html_entity_decode($this->request->get['filter_model'], ENT_QUOTES, 'UTF-8'));
    }

    if (isset($this->request->get['filter_price'])) {
      $url .= '&filter_price=' . $this->request->get['filter_price'];
    }

    if (isset($this->request->get['filter_quantity'])) {
      $url .= '&filter_quantity=' . $this->request->get['filter_quantity'];
    }

    if (isset($this->request->get['filter_status'])) {
      $url .= '&filter_status=' . $this->request->get['filter_status'];
    }

    if (isset($this->request->get['sort'])) {
      $url .= '&sort=' . $this->request->get['sort'];
    }

    if (isset($this->request->get['order'])) {
      $url .= '&order=' . $this->request->get['order'];
    }

    if (isset($this->request->get['page'])) {
      $url .= '&page=' . $this->request->get['page'];
    }

    $data['breadcrumbs'] = array();

    $data['breadcrumbs'][] = array(
      'text' => $this->language->get('text_home'),
      'href' => $this->url->link('common/dashboard', 'token=' . $this->session->data['token'], 'SSL')
    );

    $data['breadcrumbs'][] = array(
      'text' => $this->language->get('heading_title'),
      'href' => $this->url->link('catalog/lgi_product', 'token=' . $this->session->data['token'] . $url, 'SSL')
    );

    if (!isset($this->request->get['product_id'])) {
      $data['action'] = $this->url->link('catalog/lgi_product/add', 'token=' . $this->session->data['token'] . $url, 'SSL');
    } else {
      $data['action'] = $this->url->link('catalog/lgi_product/edit', 'token=' . $this->session->data['token'] . '&product_id=' . $this->request->get['product_id'] . $url, 'SSL');
    }

    $data['cancel'] = $this->url->link('catalog/lgi_product', 'token=' . $this->session->data['token'] . $url, 'SSL');

    if (isset($this->request->get['product_id']) && ($this->request->server['REQUEST_METHOD'] != 'POST')) {
      $product_info = $this->model_catalog_lgi_product->getProduct($this->request->get['product_id']);
    }

    $data['token'] = $this->session->data['token'];

    $this->load->model('localisation/language');

    $data['languages'] = $this->model_localisation_language->getLanguages();

    if (isset($this->request->post['product_description'])) {
      $data['product_description'] = $this->request->post['product_description'];
    } elseif (isset($this->request->get['product_id'])) {
      $data['product_description'] = $this->model_catalog_lgi_product->getProductDescriptions($this->request->get['product_id']);
    } else {
      $data['product_description'] = array();
    }

    if (isset($this->request->post['image'])) {
      $data['image'] = $this->request->post['image'];
    } elseif (!empty($product_info)) {
      $data['image'] = $product_info['image'];
    } else {
      $data['image'] = '';
    }

    $this->load->model('tool/image');

    if (isset($this->request->post['image']) && is_file(DIR_IMAGE . $this->request->post['image'])) {
      $data['thumb'] = $this->model_tool_image->resize($this->request->post['image'], 100, 100);
    } elseif (!empty($product_info) && is_file(DIR_IMAGE . $product_info['image'])) {
      $data['thumb'] = $this->model_tool_image->resize($product_info['image'], 100, 100);
    } else {
      $data['thumb'] = $this->model_tool_image->resize('no_image.png', 100, 100);
    }

    $data['placeholder'] = $this->model_tool_image->resize('no_image.png', 100, 100);
    
    if (isset($this->request->post['model'])) {
      $data['model'] = $this->request->post['model'];
    } elseif (!empty($product_info)) {
      $data['model'] = $product_info['model'];
    } else {
      $data['model'] = '';
    }

    if (isset($this->request->post['sku'])) {
      $data['sku'] = $this->request->post['sku'];
    } elseif (!empty($product_info)) {
      $data['sku'] = $product_info['sku'];
    } else {
      $data['sku'] = '';
    }

    if (isset($this->request->post['upc'])) {
      $data['upc'] = $this->request->post['upc'];
    } elseif (!empty($product_info)) {
      $data['upc'] = $product_info['upc'];
    } else {
      $data['upc'] = '';
    }

    if (isset($this->request->post['ean'])) {
      $data['ean'] = $this->request->post['ean'];
    } elseif (!empty($product_info)) {
      $data['ean'] = $product_info['ean'];
    } else {
      $data['ean'] = '';
    }

    if (isset($this->request->post['jan'])) {
      $data['jan'] = $this->request->post['jan'];
    } elseif (!empty($product_info)) {
      $data['jan'] = $product_info['jan'];
    } else {
      $data['jan'] = '';
    }

    if (isset($this->request->post['isbn'])) {
      $data['isbn'] = $this->request->post['isbn'];
    } elseif (!empty($product_info)) {
      $data['isbn'] = $product_info['isbn'];
    } else {
      $data['isbn'] = '';
    }

    if (isset($this->request->post['mpn'])) {
      $data['mpn'] = $this->request->post['mpn'];
    } elseif (!empty($product_info)) {
      $data['mpn'] = $product_info['mpn'];
    } else {
      $data['mpn'] = '';
    }

    if (isset($this->request->post['location'])) {
      $data['location'] = $this->request->post['location'];
    } elseif (!empty($product_info)) {
      $data['location'] = $product_info['location'];
    } else {
      $data['location'] = '';
    }
    
    //lgis
    if (isset($this->request->get['product_id'])) {
      foreach ($this->model_catalog_lgi_product->getProductDescriptions($this->request->get['product_id']) as $pdname) {
        $product_name = $pdname['name'];
      }
    }
      
    if (isset($this->request->post['product_name'])) {
      $data['product_name'] = $this->request->post['product_name'];
    } elseif (!empty($product_name)) {
      $data['product_name'] = $product_name;
    } else {
      $data['product_name'] = '';
    }
    
    $this->load->model('setting/setting');
    $data['config'] = $this->model_setting_setting->getSetting('config');
    $data['countries'] = $this->model_catalog_lgi_product->getCountry();  
      
    if (isset($this->request->post['ori_country'])) {
      $data['ori_country'] = $this->request->post['ori_country'];
    } else if (isset($product_info)) {
      $data['ori_country'] = $product_info['ori_country'];
    } else {
      $data['ori_country'] = '';
    }
      
    if (isset($this->request->post['product_cost'])) {
      $data['product_cost'] = $this->request->post['product_cost'];
    } else if (isset($product_info)) {
      $data['product_cost'] = $product_info['product_cost'];
    } else {
      $data['product_cost'] = '';
    }
      
    $data['couriers'] = $this->model_catalog_lgi_product->getCourier();
    
    if (isset($this->request->post['shipping_method'])) {
      $data['shipping_method'] = $this->request->post['shipping_method'];
    } else if (isset($product_info)) {
      $data['shipping_method'] = $product_info['shipping_method'];
    } else {
      $data['shipping_method'] = '0';
    }
      
    if (isset($this->request->post['prefered_shipping'])) {
      $data['prefered_shipping'] = $this->request->post['prefered_shipping'];
    } else if (isset($product_info)) {
      $data['prefered_shipping'] = $product_info['prefered_shipping'];
    } else {
      $data['prefered_shipping'] = '0';
    }
      
    if (isset($this->request->post['shipping_cost'])) {
      $data['shipping_cost'] = $this->request->post['shipping_cost'];
    } else if (isset($product_info)) {
      $data['shipping_cost'] = $product_info['shipping_cost'];
    } else {
      $data['shipping_cost'] = '';
    }
      
    if (isset($this->request->post['vtotal'])) {
      $data['vtotal'] = $this->request->post['vtotal'];
    } else if (isset($product_info)) {
      $data['vtotal'] = $product_info['vtotal'];
    } else {
      $data['vtotal'] = '';
    }
      
    if (isset($this->request->post['product_url'])) {
      $data['product_url'] = $this->request->post['product_url'];
    } else if (isset($product_info)) {
      $data['product_url'] = $product_info['product_url'];
    } else {
      $data['product_url'] = '';
    }
      
    $data['vendors'] = $this->model_catalog_lgi_product->getVendors();
    
    if (isset($this->request->post['vendor'])) {
      $data['vendor'] = $this->request->post['vendor'];
    } elseif (isset($product_info)) {
      $data['vendor'] = $product_info['vendor'];
    } else {
      $data['vendor'] = 0;
    }
          
    if (isset($this->request->post['wholesale'])) {
      $data['wholesale'] = $this->request->post['wholesale'];
    } else if (isset($product_info)) {
      $data['wholesale'] = $product_info['wholesale'];
    } else {
      $data['wholesale'] = '';
    }
      
    if (isset($this->request->post['company'])) {
      $data['company'] = $this->request->post['company'];
    } else if (isset($product_info)) {
      $data['company'] = $product_info['company'];
    } else {
      $data['company'] = '';
    }
      
    if (isset($this->request->post['vname'])) {
      $data['vname'] = $this->request->post['vname'];
    } else if (isset($product_info)) {
      $data['vname'] = $product_info['vname'];
    } else {
      $data['vname'] = '';
    }
      
    if (isset($this->request->post['telephone'])) {
      $data['telephone'] = $this->request->post['telephone'];
    } else if (isset($product_info)) {
      $data['telephone'] = $product_info['telephone'];
    } else {
      $data['telephone'] = '';
    }
      
    if (isset($this->request->post['fax'])) {
      $data['fax'] = $this->request->post['fax'];
    } else if (isset($product_info)) {
      $data['fax'] = $product_info['fax'];
    } else {
      $data['fax'] = '';
    }
      
    if (isset($this->request->post['email'])) {
      $data['email'] = $this->request->post['email'];
    } else if (isset($product_info)) {
      $data['email'] = $product_info['email'];
    } else {
      $data['email'] = '';
    }
      
    if (isset($this->request->post['paypal_email'])) {
      $data['paypal_email'] = $this->request->post['paypal_email'];
    } else if (isset($product_info)) {
      $data['paypal_email'] = $product_info['paypal_email'];
    } else {
      $data['paypal_email'] = '';
    }
      
    if (isset($this->request->post['vendor_description'])) {
      $data['vendor_description'] = $this->request->post['vendor_description'];
    } else if (isset($product_info)) {
      $data['vendor_description'] = $product_info['vendor_description'];
    } else {
      $data['vendor_description'] = '';
    }
          
    if (isset($this->request->post['vendor_address'])) {
      $data['vendor_address'] = $this->request->post['vendor_address'];
    } else if (isset($product_info)) {
      $data['vendor_address'] = $product_info['address'];
    } else {
      $data['vendor_address'] = '';
    }
      
      
    if (isset($this->request->post['vendor_country_zone'])) {
      $data['vendor_country_zone'] = $this->request->post['vendor_country_zone'];
    } else if (isset($product_info)) {
      if (isset($product_info['country_id']) && isset($product_info['zone_id'])) {
        $this->load->model('localisation/zone');
        $zone = $this->model_localisation_zone->getZone((int)$product_info['zone_id']);
        if ($zone) {
          $vendor_zone = $zone['name'];
        } else {
          $vendor_zone =  $this->language->get('text_none');
        }
        
        $this->load->model('localisation/country');
        $country = $this->model_localisation_country->getCountry((int)$product_info['country_id']);
        $vendor_country = $country['name'];
      } else {
        $vendor_zone = '';
        $vendor_country = '';
      }
      $data['vendor_country_zone'] = $vendor_country . ', ' . $vendor_zone;
    } else {
      $data['vendor_country_zone'] = '';
    }
      
    if (isset($this->request->post['store_url'])) {
      $data['store_url'] = $this->request->post['store_url'];
    } else if (isset($product_info)) {
      $data['store_url'] = $product_info['store_url'];
    } else {
      $data['store_url'] = '';
    }
      
    $this->load->model('localisation/geo_zone');
    $data['geo_zones'] = $this->model_localisation_geo_zone->getGeoZones();
      
    if (isset($this->request->post['product_shipping'])) {
      $data['product_shippings'] = $this->request->post['product_shipping'];
    } elseif (isset($this->request->get['product_id'])) {
      $data['product_shippings'] = $this->model_catalog_lgi_product->getProductShippings($this->request->get['product_id']);
    } else {
      $data['product_shippings'] = array();
    }
    //lgie

    $this->load->model('setting/store');

    $data['stores'] = $this->model_setting_store->getStores();

    if (isset($this->request->post['product_store'])) {
      $data['product_store'] = $this->request->post['product_store'];
    } elseif (isset($this->request->get['product_id'])) {
      $data['product_store'] = $this->model_catalog_lgi_product->getProductStores($this->request->get['product_id']);
    } else {
      $data['product_store'] = array(0);
    }

    if (isset($this->request->post['keyword'])) {
      $data['keyword'] = $this->request->post['keyword'];
    } elseif (!empty($product_info)) {
      $data['keyword'] = $product_info['keyword'];
    } else {
      $data['keyword'] = '';
    }

    if (isset($this->request->post['shipping'])) {
      $data['shipping'] = $this->request->post['shipping'];
    } elseif (!empty($product_info)) {
      $data['shipping'] = $product_info['shipping'];
    } else {
      $data['shipping'] = 1;
    }

    if (isset($this->request->post['price'])) {
      $data['price'] = $this->request->post['price'];
    } elseif (!empty($product_info)) {
      $data['price'] = $product_info['price'];
    } else {
      $data['price'] = '';
    }

    $this->load->model('catalog/recurring');

    $data['recurrings'] = $this->model_catalog_recurring->getRecurrings();

    if (isset($this->request->post['product_recurrings'])) {
      $data['product_recurrings'] = $this->request->post['product_recurrings'];
    } elseif (!empty($product_info)) {
      $data['product_recurrings'] = $this->model_catalog_lgi_product->getRecurrings($product_info['product_id']);
    } else {
      $data['product_recurrings'] = array();
    }

    $this->load->model('localisation/tax_class');

    $data['tax_classes'] = $this->model_localisation_tax_class->getTaxClasses();

    if (isset($this->request->post['tax_class_id'])) {
      $data['tax_class_id'] = $this->request->post['tax_class_id'];
    } elseif (!empty($product_info)) {
      $data['tax_class_id'] = $product_info['tax_class_id'];
    } else {
      $data['tax_class_id'] = 0;
    }

    if (isset($this->request->post['date_available'])) {
      $data['date_available'] = $this->request->post['date_available'];
    } elseif (!empty($product_info)) {
      $data['date_available'] = ($product_info['date_available'] != '0000-00-00') ? $product_info['date_available'] : '';
    } else {
      $data['date_available'] = date('Y-m-d');
    }

    if (isset($this->request->post['quantity'])) {
      $data['quantity'] = $this->request->post['quantity'];
    } elseif (!empty($product_info)) {
      $data['quantity'] = $product_info['quantity'];
    } else {
      $data['quantity'] = 1;
    }

    if (isset($this->request->post['minimum'])) {
      $data['minimum'] = $this->request->post['minimum'];
    } elseif (!empty($product_info)) {
      $data['minimum'] = $product_info['minimum'];
    } else {
      $data['minimum'] = 1;
    }

    if (isset($this->request->post['subtract'])) {
      $data['subtract'] = $this->request->post['subtract'];
    } elseif (!empty($product_info)) {
      $data['subtract'] = $product_info['subtract'];
    } else {
      $data['subtract'] = 1;
    }

    if (isset($this->request->post['sort_order'])) {
      $data['sort_order'] = $this->request->post['sort_order'];
    } elseif (!empty($product_info)) {
      //$data['sort_order'] = $product_info['sort_order'];
      //lgis
      $data['sort_order'] = $product_info['psort_order'];
      //lgie
    } else {
      $data['sort_order'] = 1;
    }

    $this->load->model('localisation/stock_status');

    $data['stock_statuses'] = $this->model_localisation_stock_status->getStockStatuses();

    if (isset($this->request->post['stock_status_id'])) {
      $data['stock_status_id'] = $this->request->post['stock_status_id'];
    } elseif (!empty($product_info)) {
      $data['stock_status_id'] = $product_info['stock_status_id'];
    } else {
      $data['stock_status_id'] = 0;
    }

    if (isset($this->request->post['status'])) {
      $data['status'] = $this->request->post['status'];
    } elseif (!empty($product_info)) {
      $data['status'] = $product_info['status'];
    } else {
      $data['status'] = true;
    }

    if (isset($this->request->post['weight'])) {
      $data['weight'] = $this->request->post['weight'];
    } elseif (!empty($product_info)) {
      $data['weight'] = $product_info['weight'];
    } else {
      $data['weight'] = '';
    }

    $this->load->model('localisation/weight_class');

    $data['weight_classes'] = $this->model_localisation_weight_class->getWeightClasses();

    if (isset($this->request->post['weight_class_id'])) {
      $data['weight_class_id'] = $this->request->post['weight_class_id'];
    } elseif (!empty($product_info)) {
      $data['weight_class_id'] = $product_info['weight_class_id'];
    } else {
      $data['weight_class_id'] = $this->config->get('config_weight_class_id');
    }

    if (isset($this->request->post['length'])) {
      $data['length'] = $this->request->post['length'];
    } elseif (!empty($product_info)) {
      $data['length'] = $product_info['length'];
    } else {
      $data['length'] = '';
    }

    if (isset($this->request->post['width'])) {
      $data['width'] = $this->request->post['width'];
    } elseif (!empty($product_info)) {
      $data['width'] = $product_info['width'];
    } else {
      $data['width'] = '';
    }

    if (isset($this->request->post['height'])) {
      $data['height'] = $this->request->post['height'];
    } elseif (!empty($product_info)) {
      $data['height'] = $product_info['height'];
    } else {
      $data['height'] = '';
    }

    $this->load->model('localisation/length_class');

    $data['length_classes'] = $this->model_localisation_length_class->getLengthClasses();

    if (isset($this->request->post['length_class_id'])) {
      $data['length_class_id'] = $this->request->post['length_class_id'];
    } elseif (!empty($product_info)) {
      $data['length_class_id'] = $product_info['length_class_id'];
    } else {
      $data['length_class_id'] = $this->config->get('config_length_class_id');
    }

    $this->load->model('catalog/manufacturer');

    if (isset($this->request->post['manufacturer_id'])) {
      $data['manufacturer_id'] = $this->request->post['manufacturer_id'];
    } elseif (!empty($product_info)) {
      $data['manufacturer_id'] = $product_info['manufacturer_id'];
    } else {
      $data['manufacturer_id'] = 0;
    }

    if (isset($this->request->post['manufacturer'])) {
      $data['manufacturer'] = $this->request->post['manufacturer'];
    } elseif (!empty($product_info)) {
      $manufacturer_info = $this->model_catalog_manufacturer->getManufacturer($product_info['manufacturer_id']);

      if ($manufacturer_info) {
        $data['manufacturer'] = $manufacturer_info['name'];
      } else {
        $data['manufacturer'] = '';
      }
    } else {
      $data['manufacturer'] = '';
    }

    // Categories
    $this->load->model('catalog/category');

    if (isset($this->request->post['product_category'])) {
      $categories = $this->request->post['product_category'];
    } elseif (isset($this->request->get['product_id'])) {
      $categories = $this->model_catalog_lgi_product->getProductCategories($this->request->get['product_id']);
    } else {
      $categories = array();
    }

    $data['product_categories'] = array();

    foreach ($categories as $category_id) {
      $category_info = $this->model_catalog_category->getCategory($category_id);

      if ($category_info) {
        $data['product_categories'][] = array(
          'category_id' => $category_info['category_id'],
          'name' => ($category_info['path']) ? $category_info['path'] . ' &gt; ' . $category_info['name'] : $category_info['name']
        );
      }
    }

    // Filters
    $this->load->model('catalog/filter');

    if (isset($this->request->post['product_filter'])) {
      $filters = $this->request->post['product_filter'];
    } elseif (isset($this->request->get['product_id'])) {
      $filters = $this->model_catalog_lgi_product->getProductFilters($this->request->get['product_id']);
    } else {
      $filters = array();
    }

    $data['product_filters'] = array();

    foreach ($filters as $filter_id) {
      $filter_info = $this->model_catalog_filter->getFilter($filter_id);

      if ($filter_info) {
        $data['product_filters'][] = array(
          'filter_id' => $filter_info['filter_id'],
          'name'      => $filter_info['group'] . ' &gt; ' . $filter_info['name']
        );
      }
    }

    // Attributes
    $this->load->model('catalog/attribute');

    if (isset($this->request->post['product_attribute'])) {
      $product_attributes = $this->request->post['product_attribute'];
    } elseif (isset($this->request->get['product_id'])) {
      $product_attributes = $this->model_catalog_lgi_product->getProductAttributes($this->request->get['product_id']);
    } else {
      $product_attributes = array();
    }

    $data['product_attributes'] = array();

    foreach ($product_attributes as $product_attribute) {
      $attribute_info = $this->model_catalog_attribute->getAttribute($product_attribute['attribute_id']);

      if ($attribute_info) {
        $data['product_attributes'][] = array(
          'attribute_id'                  => $product_attribute['attribute_id'],
          'name'                          => $attribute_info['name'],
          'product_attribute_description' => $product_attribute['product_attribute_description']
        );
      }
    }

    // Options
    $this->load->model('catalog/option');

    if (isset($this->request->post['product_option'])) {
      $product_options = $this->request->post['product_option'];
    } elseif (isset($this->request->get['product_id'])) {
      $product_options = $this->model_catalog_lgi_product->getProductOptions($this->request->get['product_id']);
    } else {
      $product_options = array();
    }

    $data['product_options'] = array();

    foreach ($product_options as $product_option) {
      $product_option_value_data = array();

      if (isset($product_option['product_option_value'])) {
        foreach ($product_option['product_option_value'] as $product_option_value) {
          $product_option_value_data[] = array(
            'product_option_value_id' => $product_option_value['product_option_value_id'],
            'option_value_id'         => $product_option_value['option_value_id'],
            'quantity'                => $product_option_value['quantity'],
            'subtract'                => $product_option_value['subtract'],
            'price'                   => $product_option_value['price'],
            'price_prefix'            => $product_option_value['price_prefix'],
            'points'                  => $product_option_value['points'],
            'points_prefix'           => $product_option_value['points_prefix'],
            'weight'                  => $product_option_value['weight'],
            'weight_prefix'           => $product_option_value['weight_prefix']
          );
        }
      }

      $data['product_options'][] = array(
        'product_option_id'    => $product_option['product_option_id'],
        'product_option_value' => $product_option_value_data,
        'option_id'            => $product_option['option_id'],
        'name'                 => $product_option['name'],
        'type'                 => $product_option['type'],
        'value'                => isset($product_option['value']) ? $product_option['value'] : '',
        'required'             => $product_option['required']
      );
    }

    $data['option_values'] = array();

    foreach ($data['product_options'] as $product_option) {
      if ($product_option['type'] == 'select' || $product_option['type'] == 'radio' || $product_option['type'] == 'checkbox' || $product_option['type'] == 'image') {
        if (!isset($data['option_values'][$product_option['option_id']])) {
          $data['option_values'][$product_option['option_id']] = $this->model_catalog_option->getOptionValues($product_option['option_id']);
        }
      }
    }

    $this->load->model('customer/customer_group');

    $data['customer_groups'] = $this->model_customer_customer_group->getCustomerGroups();

    if (isset($this->request->post['product_discount'])) {
      $product_discounts = $this->request->post['product_discount'];
    } elseif (isset($this->request->get['product_id'])) {
      $product_discounts = $this->model_catalog_lgi_product->getProductDiscounts($this->request->get['product_id']);
    } else {
      $product_discounts = array();
    }

    $data['product_discounts'] = array();

    foreach ($product_discounts as $product_discount) {
      $data['product_discounts'][] = array(
        'customer_group_id' => $product_discount['customer_group_id'],
        'quantity'          => $product_discount['quantity'],
        'priority'          => $product_discount['priority'],
        'price'             => $product_discount['price'],
        'date_start'        => ($product_discount['date_start'] != '0000-00-00') ? $product_discount['date_start'] : '',
        'date_end'          => ($product_discount['date_end'] != '0000-00-00') ? $product_discount['date_end'] : ''
      );
    }

    if (isset($this->request->post['product_special'])) {
      $product_specials = $this->request->post['product_special'];
    } elseif (isset($this->request->get['product_id'])) {
      $product_specials = $this->model_catalog_lgi_product->getProductSpecials($this->request->get['product_id']);
    } else {
      $product_specials = array();
    }

    $data['product_specials'] = array();

    foreach ($product_specials as $product_special) {
      $data['product_specials'][] = array(
        'customer_group_id' => $product_special['customer_group_id'],
        'priority'          => $product_special['priority'],
        'price'             => $product_special['price'],
        'date_start'        => ($product_special['date_start'] != '0000-00-00') ? $product_special['date_start'] : '',
        'date_end'          => ($product_special['date_end'] != '0000-00-00') ? $product_special['date_end'] :  ''
      );
    }

    // Images
    if (isset($this->request->post['product_image'])) {
      $product_images = $this->request->post['product_image'];
    } elseif (isset($this->request->get['product_id'])) {
      $product_images = $this->model_catalog_lgi_product->getProductImages($this->request->get['product_id']);
    } else {
      $product_images = array();
    }

    $data['product_images'] = array();

    foreach ($product_images as $product_image) {
      if (is_file(DIR_IMAGE . $product_image['image'])) {
        $image = $product_image['image'];
        $thumb = $product_image['image'];
      } else {
        $image = '';
        $thumb = 'no_image.png';
      }

      $data['product_images'][] = array(
        'image'      => $image,
        'thumb'      => $this->model_tool_image->resize($thumb, 100, 100),
        'sort_order' => $product_image['sort_order']
      );
    }

    // Downloads
    $this->load->model('catalog/download');

    if (isset($this->request->post['product_download'])) {
      $product_downloads = $this->request->post['product_download'];
    } elseif (isset($this->request->get['product_id'])) {
      $product_downloads = $this->model_catalog_lgi_product->getProductDownloads($this->request->get['product_id']);
    } else {
      $product_downloads = array();
    }

    $data['product_downloads'] = array();

    foreach ($product_downloads as $download_id) {
      $download_info = $this->model_catalog_download->getDownload($download_id);

      if ($download_info) {
        $data['product_downloads'][] = array(
          'download_id' => $download_info['download_id'],
          'name'        => $download_info['name']
        );
      }
    }

    if (isset($this->request->post['product_related'])) {
      $products = $this->request->post['product_related'];
    } elseif (isset($this->request->get['product_id'])) {
      $products = $this->model_catalog_lgi_product->getProductRelated($this->request->get['product_id']);
    } else {
      $products = array();
    }

    $data['product_relateds'] = array();

    foreach ($products as $product_id) {
      $related_info = $this->model_catalog_lgi_product->getProduct($product_id);

      if ($related_info) {
        $data['product_relateds'][] = array(
          'product_id' => $related_info['product_id'],
          'name'       => $related_info['name']
        );
      }
    }

    if (isset($this->request->post['points'])) {
      $data['points'] = $this->request->post['points'];
    } elseif (!empty($product_info)) {
      $data['points'] = $product_info['points'];
    } else {
      $data['points'] = '';
    }

    if (isset($this->request->post['product_reward'])) {
      $data['product_reward'] = $this->request->post['product_reward'];
    } elseif (isset($this->request->get['product_id'])) {
      $data['product_reward'] = $this->model_catalog_lgi_product->getProductRewards($this->request->get['product_id']);
    } else {
      $data['product_reward'] = array();
    }

    if (isset($this->request->post['product_layout'])) {
      $data['product_layout'] = $this->request->post['product_layout'];
    } elseif (isset($this->request->get['product_id'])) {
      $data['product_layout'] = $this->model_catalog_lgi_product->getProductLayouts($this->request->get['product_id']);
    } else {
      $data['product_layout'] = array();
    }

    $this->load->model('design/layout');

    $data['layouts'] = $this->model_design_layout->getLayouts();

    $data['header'] = $this->load->controller('common/header');
    $data['column_left'] = $this->load->controller('common/column_left');
    $data['footer'] = $this->load->controller('common/footer');

    $this->response->setOutput($this->load->view('catalog/lgi_product_form.tpl', $data));
  }
  
  //lgis
  public function vendor() {
    $this->load->model('catalog/lgi_product');
        
    if (isset($this->request->get['vendor_id'])) {
      $vendor_id = $this->request->get['vendor_id'];
    } else {
      $vendor_id = 0;
    }
    
    $results = $this->model_catalog_lgi_product->getVendorsByVendorId($vendor_id);
    
    $this->response->addHeader('Content-Type: application/json');
    $this->response->setOutput(json_encode($results));
  }
      
  //lgie

  public function autocomplete() {
    $json = array();

    //if (isset($this->request->get['filter_name']) || isset($this->request->get['filter_model'])) {
    //lgis
    if (isset($this->request->get['filter_name']) || isset($this->request->get['filter_model']) || isset($this->request->get['filter_sku'])) {
    //lgie
      $this->load->model('catalog/lgi_product');
      $this->load->model('catalog/option');

      if (isset($this->request->get['filter_name'])) {
        $filter_name = $this->request->get['filter_name'];
      } else {
        $filter_name = '';
      }

      if (isset($this->request->get['filter_model'])) {
        $filter_model = $this->request->get['filter_model'];
      } else {
        $filter_model = '';
      }
      
      //lgis
      if (isset($this->request->get['filter_sku'])) {
        $filter_sku = $this->request->get['filter_sku'];
      } else {
        $filter_sku = '';
      }
      //lgie
      
      if (isset($this->request->get['limit'])) {
        $limit = $this->request->get['limit'];
      } else {
        $limit = 5;
      }

      $filter_data = array(
        'filter_name'  => $filter_name,
        //lgis
        'filter_sku'   => $filter_sku,
        //lgie
        'filter_model' => $filter_model,
        'start'        => 0,
        'limit'        => $limit
      );

      $results = $this->model_catalog_lgi_product->getProducts($filter_data);

      foreach ($results as $result) {
        $option_data = array();

        $product_options = $this->model_catalog_lgi_product->getProductOptions($result['product_id']);

        foreach ($product_options as $product_option) {
          $option_info = $this->model_catalog_option->getOption($product_option['option_id']);

          if ($option_info) {
            $product_option_value_data = array();

            foreach ($product_option['product_option_value'] as $product_option_value) {
              $option_value_info = $this->model_catalog_option->getOptionValue($product_option_value['option_value_id']);

              if ($option_value_info) {
                $product_option_value_data[] = array(
                  'product_option_value_id' => $product_option_value['product_option_value_id'],
                  'option_value_id'         => $product_option_value['option_value_id'],
                  'name'                    => $option_value_info['name'],
                  'price'                   => (float)$product_option_value['price'] ? $this->currency->format($product_option_value['price'], $this->config->get('config_currency')) : false,
                  'price_prefix'            => $product_option_value['price_prefix']
                );
              }
            }

            $option_data[] = array(
              'product_option_id'    => $product_option['product_option_id'],
              'product_option_value' => $product_option_value_data,
              'option_id'            => $product_option['option_id'],
              'name'                 => $option_info['name'],
              'type'                 => $option_info['type'],
              'value'                => $product_option['value'],
              'required'             => $product_option['required']
            );
          }
        }

        $json[] = array(
          'product_id' => $result['product_id'],
          //lgis
          'sku'        => $result['sku'],
          //lgie
          'name'       => strip_tags(html_entity_decode($result['name'], ENT_QUOTES, 'UTF-8')),
          'model'      => $result['model'],
          'option'     => $option_data,
          'price'      => $result['price']
        );
      }
    }

    $this->response->addHeader('Content-Type: application/json');
    $this->response->setOutput(json_encode($json));
  }

  public function batch() {
    

    $this->language->load('catalog/product');

    $this->document->setTitle($this->language->get('heading_title'));

    $this->load->model('catalog/lgi_product');

    if (isset($this->request->post['selected']) && $this->validateBatch()) {

      $enable = $this->request->get['enable'];
      $product_ids = $this->request->post['selected'];
      $this->model_catalog_lgi_product->batchSetProducts($product_ids, $enable, $this->user->getLP());

      $this->session->data['success'] = $this->language->get('text_success');

      $url = '';

      if (isset($this->request->get['filter_name'])) {
        $url .= '&filter_name=' . urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES, 'UTF-8'));
      }

      if (isset($this->request->get['filter_model'])) {
        $url .= '&filter_model=' . urlencode(html_entity_decode($this->request->get['filter_model'], ENT_QUOTES, 'UTF-8'));
      }

      if (isset($this->request->get['filter_price'])) {
        $url .= '&filter_price=' . $this->request->get['filter_price'];
      }

      if (isset($this->request->get['filter_quantity'])) {
        $url .= '&filter_quantity=' . $this->request->get['filter_quantity'];
      }

      if (isset($this->request->get['filter_status'])) {
        $url .= '&filter_status=' . $this->request->get['filter_status'];
      }

      if (isset($this->request->get['sort'])) {
        $url .= '&sort=' . $this->request->get['sort'];
      }

      if (isset($this->request->get['order'])) {
        $url .= '&order=' . $this->request->get['order'];
      }

      if (isset($this->request->get['page'])) {
        $url .= '&page=' . $this->request->get['page'];
      }

      $this->response->redirect($this->url->link('catalog/lgi_product', 'token=' . $this->session->data['token'] . $url, 'SSL'));
    }

    $this->getList();
  }

  protected function validateBatch() {
    if (!$this->user->hasPermission('modify', 'catalog/lgi_product')) {
      $this->error['warning'] = $this->language->get('error_permission');
    }
    if(!isset($this->request->get['enable']) || $this->request->get['enable']>1) {
      $this->error['warning'] = '参数错误';
    }
    return !$this->error;
  }
}